﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace ERP_RORZE_TOOL.Common
{
    public class ToolConstants
    {
        #region Prefix
        public const string Prefix = "Tool";
        #endregion

        #region Entities
        public const string DatabaseName = "[rrc_database]";

        public class Entities
        {
            public const string FullName = "FullName";
            #region Borrow
            public class Borrow
            {
                public const string Name = "333_Borrow";
                public class FieldName
                {
                    public const string ID = "ID";
                    public const string Date = "Date";
                    public const string ToolID = "ToolID";
                    public const string StaffID = "StaffID";
                    public const string MachineID = "MachineID";
                    public const string Quantity = "Quantity";
                    public const string Note = "Note";
                    public const string ToolOrQTool = "ToolOrQTool";

                }
            }
            #endregion

            #region Broken
            public class Broken
            {
                public const string Name = "333_Broken";
                public class FieldName
                {
                    public const string ID = "ID";
                    public const string Date = "Date";
                    public const string ToolID = "ToolID";
                    public const string MachineID = "MachineID";
                    public const string MistakeID = "MistakeID";
                    public const string StatusName = "StatusName";
                    public const string LossNo = "LossNo";
                    public const string PartNo = "PartNo";
                    public const string Quantity = "Quantity";
                    public const string ProcessStatusID = "ProcessStatusID";
                    public const string RotateID = "RotateID";
                    public const string StandardSpeed = "StandardSpeed";
                    public const string RealitySpeed = "RealitySpeed";
                    public const string Process = "Process";
                    public const string ToKind = "ToKind";
                    public const string Note = "Note";
                    public const string ToolOrQTool = "ToolOrQTool";
                }
            }
            #endregion

            #region Frequency
            public class Frequency
            {
                public const string Name = "Frequency";
                public class FieldName
                {
                    public const string FrequencyID = "FrequencyID";
                    public const string FrequencyName = "FrequencyName";
                    public const string FrequencyName_English = "FrequencyName_English";
                    public const string FullName = "FullName";
                }
            }
            #endregion

            #region Import
            public class Import
            {
                public const string Name = "333_Import";
                public class FieldName
                {
                    public const string ID = "ID";
                    public const string Date = "Date";
                    public const string ToolID = "ToolID";
                    public const string PriceJPY = "PriceJPY";
                    public const string MakerID = "MakerID";
                    public const string SupplierID = "SupplierID";
                    public const string Quantity = "Quantity";
                    public const string Note = "Note";
                }
            }
            #endregion

            #region JustNew
            public class JustNew
            {
                public const string Name = "333_JustNew";
                public class FieldName
                {
                    public const string ID = "ID";
                    public const string Date = "Date";
                    public const string ToolID = "ToolID";
                    public const string Quantity = "Quantity";
                    public const string ToolOrQTool = "ToolOrQTool";
                    public const string Note = "Note";
                }
            }
            #endregion

            #region Kind
            public class Kind
            {
                public const string Name = "Kind";
                public class FieldName
                {
                    public const string KindID = "KindID";
                    public const string KindName = "KindName";
                    public const string FullName = "FullName";
                }
            }
            #endregion

            #region Mistake
            public class Mistake
            {
                public const string Name = "Mistake";
                public class FieldName
                {
                    public const string MistakeID = "MistakeID";
                    public const string MistakeEnglish = "MistakeEnglish";
                    public const string MistakeJanpanese = "MistakeJanpanese";
                    public const string FullName = "FullName";
                }
            }
            #endregion

            #region ProcessStatus
            public class ProcessStatus
            {
                public const string Name = "ProcessStatus";
                public class FieldName
                {
                    public const string ProcessStatusID = "ProcessStatusID";
                    public const string ProcessStatusJapanese = "ProcessStatusJapanese";
                    public const string FullName = "FullName";
                }
            }
            #endregion

            #region QTool
            public class QTool
            {
                public const string Name = "QTool";
                public class FieldName
                {
                    public const string QToolID = "QToolID";
                    public const string MakerID = "MakerID";
                    public const string MakerName = "MakerName";
                    public const string RRIName = "RRIName";
                    public const string Price = "Price";
                    public const string FrequencyID = "FrequencyID";
                    public const string ToolGroupID = "ToolGroupID";
                    public const string SafeQty = "SafeQty";
                }
            }
            #endregion

            #region Return
            public class Return
            {
                public const string Name = "333_Return";
                public class FieldName
                {
                    public const string ID = "ID";
                    public const string Date = "Date";
                    public const string StaffID = "StaffID";
                    public const string MachineID = "MachineID";
                    public const string ToolID = "ToolID";
                    public const string StatusName = "StatusName";
                    public const string Quantity = "Quantity";
                    public const string Note = "Note";
                    public const string ToolOrQTool = "ToolOrQTool";
                }
            }
            #endregion

            #region Rotate
            public class Rotate
            {
                public const string Name = "Rotate";
                public class FieldName
                {
                    public const string RotateID = "RotateID";
                    public const string Rotate_English = "Rotate_English";
                    public const string Rotate_Japanese = "Rotate_Japanese";
                    public const string FullName = "FullName";
                }
            }
            #endregion

            #region Tool
            public class Tool
            {
                public const string Name = "333_Tool";
                public class FieldName
                {
                    public const string ToolID = "ToolID";
                    public const string ToolName = "ToolName";
                    public const string MakerToolName = "MakerToolName";
                    public const string Price = "Price";
                    public const string FrequencyID = "FrequencyID";
                    public const string ToolGroupID = "ToolGroupID";
                    public const string SafeQty = "SafeQty";
                    public const string MakerID = "MakerID";
                    public const string ToolOrQTool = "ToolOrQTool";
                    public const string FullName = "FullName";
                }
            }
            #endregion

            #region ToolGroup
            public class ToolGroup
            {
                public const string Name = "ToolGroup";
                public class FieldName
                {
                    public const string ToolGroupID = "ToolGroupID";
                    public const string ToolGroupName = "ToolGroupName";
                    public const string FullName = "FullName";
                }
            }
            #endregion

            #region ToolStatus
            public class ToolStatus
            {
                public const string Name = "ToolStatus";
                public class FieldName
                {
                    public const string StatusID = "StatusID";
                    public const string StatusName = "StatusName";
                    public const string FullName = "FullName";
                }
            }
            #endregion

            #region ExchangeRate
            public class ExchangeRate
            {
                public const string Name = "Rate";
                public class FieldName
                {
                    public const string ID = "ID";
                    public const string Rate = "Rate";
                    public const string Date = "Date";
                    public const string FullName = "FullName";
                }
            }
            #endregion

            #region Supplier
            public class Supplier
            {
                public const string Name = "Supplier";
                public class FieldName
                {
                    public const string SupplierID = "SupplierID";
                    public const string SupplierName = "SupplierName";
                    public const string Company = "Company";
                    public const string Address = "Address";
                    public const string CountryID = "CountryID";
                    public const string Telephone = "Telephone";
                    public const string Fax = "Fax";
                    public const string PIC = "PIC";
                    public const string PICSex = "PICSex";
                    public const string PICEmail = "PICEmail";
                    public const string PICPosition = "PICPosition";
                    public const string TaxCode = "TaxCode";
                    public const string BankAccount = "BankAccount";
                    public const string BankName = "BankName";
                    public const string NameOfCommodity = "NameOfCommodity";
                    public const string DeliveryTermtID = "DeliveryTermtID";
                    public const string PaymentID = "PaymentID";
                    public const string Note = "Note";
                    public const string FullName = "FullName";
                }
            }
            #endregion

            #region Maker
            public class Maker
            {
                public const string Name = "Maker";
                public class FieldName
                {
                    public const string MakerID = "MakerID";
                    public const string MakerName = "MakerName";
                    public const string EnglishName = "EnglishName";
                    public const string FullName = "FullName";
                }
            }
            #endregion

            #region Staff
            public class Staff
            {
                public const string Name = "Staff";
                public class FieldName
                {
                    public const string StaffID = "StaffID";
                    public const string StaffName = "StaffName";
                    public const string Birthday = "Birthday";
                    public const string HireDate = "HireDate";
                    public const string StopDate = "StopDate";
                    public const string GroupID = "GroupID";
                    public const string PersonalInf = "PersonalInf";
                    public const string Sex = "Sex";
                    public const string FullName = "FullName";
                }
            }
            #endregion

            #region Part
            public class Part
            {
                public const string Name = "Part";
                public class FieldName
                {
                    public const string PartNo = "PartNo";
                    //public const string PartName="PartName";
                    public const string CustomerID = "CustomerID";
                    public const string SupplierID = "SupplierID";
                    public const string UpQty = "UpQty";
                    public const string PartNoPurchase = "PartNoPurchase";
                    public const string PartEnglishName = "PartEnglishName";
                    public const string PartVietNamName = "PartVietNamName";
                    public const string MakerID = "MakerID";
                    public const string SecondSupplierID = "SecondSupplierID";
                    public const string IQID = "IQID";
                    public const string UnitID = "UnitID";
                    public const string UnitExchange = "UnitExchange";
                    public const string LeadTime = "LeadTime";
                    public const string MinQty = "MinQty";
                    public const string ROHS = "ROHS";
                    public const string MaterialID = "MaterialID";
                    public const string Weight = "Weight";
                    public const string PartSize = "PartSize";
                    public const string GreenEnvi = "GreenEnvi";
                    public const string QtyBasePrice = "QtyBasePrice";
                    public const string ExportOrImport = "ExportOrImport";
                    public const string SafeQty = "SafeQty";
                    public const string PType = "PType";
                    public const string PartClassID = "PartClassID";
                    public const string PackingNote = "PackingNote";
                    public const string Remark = "Remark";
                    public const string Marume = "Marume";
                    public const string OCountry = "OCountry";
                    public const string Dept = "Dept";
                    public const string FullName = "FullName";
                }
            }
            #endregion

            #region Machine
            public class Machine
            {
                public const string Name = "Machine";
                public class FieldName
                {
                    public const string MachineID = "MachineID";
                    public const string MakerMachineNo = "MakerMachineNo";
                    public const string FullName = "FullName";
                }
            }
            #endregion


        }
        #endregion

        #region Stored Procedure
        public class StoreProcedure
        {
            public const string GetAllWithTempTable = "Sp_333_Rpt_GetAllWithTempTable";
            public const string QTotalMachineAtFactoryBorrow = "Sp_333_Rpt_QTotalMachineAtFactory_Borrow";
            public const string FTonKhoTongHop = "Sp_333_Rpt_FTonKhoTongHop";

            public class FieldName
            {
                //Borrow Input
                public const string Total = "Total";
                public const string MachineID = "MachineID";
                public const string ToolID = "ToolID";
                public const string DaoCu = "DaoCu";

                //Just New Input
                public const string DaoMoi = "DaoMoi";

            }

            public class TemporaryTables
            {
                public const string QTotalMachineAtFactoryBorrow = "##QTotalMachineAtFactory_Borrow";
                public const string GetOne = "Sp_333_Borrow_GetOne";
                public const string Insert = "Sp_333_Borrow_Insert";
                public const string Update = "Sp_333_Borrow_Update";
                public const string Delete = "Sp_333_Borrow_Delete";
            }

            #region Basic items
            public class Borrow
            {
                public const string GetAll = "Sp_333_Borrow_GetAll";
                public const string GetAllWithDateRange = "Sp_333_Borrow_GetAllWithDateRange";
                public const string GetOne = "Sp_333_Borrow_GetOne";
                public const string Insert = "Sp_333_Borrow_Insert";
                public const string Update = "Sp_333_Borrow_Update";
                public const string Delete = "Sp_333_Borrow_Delete";
            }

            public class Broken
            {
                public const string GetAll = "Sp_333_Broken_GetAll";
                public const string GetAllWithDateRange = "Sp_333_Broken_GetAllWithDateRange";
                public const string GetOne = "Sp_333_Broken_GetOne";
                public const string Insert = "Sp_333_Broken_Insert";
                public const string Update = "Sp_333_Broken_Update";
                public const string Delete = "Sp_333_Broken_Delete";
            }

            public class Frequency
            {
                public const string GetAll = "Sp_333_Frequency_GetAll";
                public const string GetOne = "Sp_333_Frequency_GetOne";
                public const string Insert = "Sp_333_Frequency_Insert";
                public const string Update = "Sp_333_Frequency_Update";
                public const string Delete = "Sp_333_Frequency_Delete";
            }

            public class Import
            {
                public const string GetAll = "Sp_333_Import_GetAll";
                public const string GetAllWithDateRange = "Sp_333_Import_GetAllWithDateRange";
                public const string GetOne = "Sp_333_Import_GetOne";
                public const string Insert = "Sp_333_Import_Insert";
                public const string Update = "Sp_333_Import_Update";
                public const string Delete = "Sp_333_Import_Delete";
            }

            public class JustNew
            {
                public const string GetAll = "Sp_333_JustNew_GetAll";
                public const string GetAllWithDateRange = "Sp_333_JustNew_GetAllWithDateRange";
                public const string GetOne = "Sp_333_JustNew_GetOne";
                public const string Insert = "Sp_333_JustNew_Insert";
                public const string Update = "Sp_333_JustNew_Update";
                public const string Delete = "Sp_333_JustNew_Delete";
            }

            public class Kind
            {
                public const string GetAll = "Sp_333_Kind_GetAll";
                public const string GetOne = "Sp_333_Kind_GetOne";
                public const string Insert = "Sp_333_Kind_Insert";
                public const string Update = "Sp_333_Kind_Update";
                public const string Delete = "Sp_333_Kind_Delete";
            }

            public class Mistake
            {
                public const string GetAll = "Sp_333_Mistake_GetAll";
                public const string GetOne = "Sp_333_Mistake_GetOne";
                public const string Insert = "Sp_333_Mistake_Insert";
                public const string Update = "Sp_333_Mistake_Update";
                public const string Delete = "Sp_333_Mistake_Delete";
            }

            public class ProcessStatus
            {
                public const string GetAll = "Sp_333_ProcessStatus_GetAll";
                public const string GetOne = "Sp_333_ProcessStatus_GetOne";
                public const string Insert = "Sp_333_ProcessStatus_Insert";
                public const string Update = "Sp_333_ProcessStatus_Update";
                public const string Delete = "Sp_333_ProcessStatus_Delete";
            }

            public class QTool
            {
                public const string GetAll = "Sp_333_QTool_GetAll";
                public const string GetOne = "Sp_333_QTool_GetOne";
                public const string Insert = "Sp_333_QTool_Insert";
                public const string Update = "Sp_333_QTool_Update";
                public const string Delete = "Sp_333_QTool_Delete";
                public const string GetAllLeftJoin = "Sp_333_QTool_GetAllLeftJoin";
                public const string GetOneLeftJoin = "Sp_333_QTool_GetOneLeftJoin";
            }

            public class Return
            {
                public const string GetAll = "Sp_333_Return_GetAll";
                public const string GetAllWithDateRange = "Sp_333_Return_GetAllWithDateRange";
                public const string GetOne = "Sp_333_Return_GetOne";
                public const string Insert = "Sp_333_Return_Insert";
                public const string Update = "Sp_333_Return_Update";
                public const string Delete = "Sp_333_Return_Delete";
            }

            public class Tool
            {
                public const string GetAll = "Sp_333_Tool_GetAll";
                public const string GetOne = "Sp_333_Tool_GetOne";
                public const string Insert = "Sp_333_Tool_Insert";
                public const string Update = "Sp_333_Tool_Update";
                public const string Delete = "Sp_333_Tool_Delete";
                public const string GetAllLeftJoin = "Sp_333_Tool_GetAllLeftJoin";
                public const string GetOneLeftJoin = "Sp_333_Tool_GetOneLeftJoin";
                public const string GetAllByToolType = "Sp_333_Tool_GetAllByToolType";
            }

            public class Rotate
            {
                public const string GetAll = "Sp_333_Rotate_GetAll";
                public const string GetOne = "Sp_333_Rotate_GetOne";
                public const string Insert = "Sp_333_Rotate_Insert";
                public const string Update = "Sp_333_Rotate_Update";
                public const string Delete = "Sp_333_Rotate_Delete";
            }

            public class ToolGroup
            {
                public const string GetAll = "Sp_333_ToolGroup_GetAll";
                public const string GetOne = "Sp_333_ToolGroup_GetOne";
                public const string Insert = "Sp_333_ToolGroup_Insert";
                public const string Update = "Sp_333_ToolGroup_Update";
                public const string Delete = "Sp_333_ToolGroup_Delete";
            }

            public class ToolStatus
            {
                public const string GetAll = "Sp_333_ToolStatus_GetAll";
                public const string GetOne = "Sp_333_ToolStatus_GetOne";
                public const string Insert = "Sp_333_ToolStatus_Insert";
                public const string Update = "Sp_333_ToolStatus_Update";
                public const string Delete = "Sp_333_ToolStatus_Delete";
            }

            public class Supplier
            {
                public const string GetAll = "Sp_333_Supplier_GetAll";
                public const string GetOne = "Sp_333_Supplier_GetOne";
                public const string Insert = "Sp_333_Supplier_Insert";
                public const string Update = "Sp_333_Supplier_Update";
                public const string Delete = "Sp_333_Supplier_Delete";
            }

            public class Maker
            {
                public const string GetAll = "Sp_333_Maker_GetAll";
                public const string GetOne = "Sp_333_Maker_GetOne";
                public const string Insert = "Sp_333_Maker_Insert";
                public const string Update = "Sp_333_Maker_Update";
                public const string Delete = "Sp_333_Maker_Delete";
            }

            public class Rate
            {
                public const string GetAll = "Sp_333_Rate_GetAll";
                public const string GetOne = "Sp_333_Rate_GetOne";
                public const string Insert = "Sp_333_Rate_Insert";
                public const string Update = "Sp_333_Rate_Update";
                public const string Delete = "Sp_333_Rate_Delete";
            }

            public class Staff
            {
                public const string GetAll = "Sp_333_Staff_GetAll";
                public const string GetOne = "Sp_333_Staff_GetOne";
                public const string Insert = "Sp_333_Staff_Insert";
                public const string Update = "Sp_333_Staff_Update";
                public const string Delete = "Sp_333_Staff_Delete";
            }

            public class Machine
            {
                public const string GetAll = "Sp_333_Machine_GetAll";
                public const string GetOne = "Sp_333_Machine_GetOne";
                public const string Insert = "Sp_333_Machine_Insert";
                public const string Update = "Sp_333_Machine_Update";
                public const string Delete = "Sp_333_Machine_Delete";
            }

            public class Part
            {
                public const string GetAll = "Sp_333_Part_GetAll";
                public const string GetOne = "Sp_333_Part_GetOne";
                public const string Insert = "Sp_333_Part_Insert";
                public const string Update = "Sp_333_Part_Update";
                public const string Delete = "Sp_333_Part_Delete";
            }
            #endregion

            public class Report
            {
                public const string FImportDetails = "Sp_333_Rpt_FImportDetails";
                public const string FImportDetailsWithRange = "Sp_333_Rpt_FImportDetailsWithRange";
                public const string FMonthlyImport = "Sp_333_Rpt_FMonthlyImport";
                public const string FUseDetails = "Sp_333_Rpt_FUseDetails";
                public const string FNewOldDetails = "Sp_333_Rpt_FNewOldDetails";
                public const string FBorrowDetails = "Sp_333_Rpt_FBorrowDetails";
                public const string FTotalMachineAtFactory_BorrowAtPresent = "Sp_333_Rpt_FTotalMachineAtFactory_BorrowAtPresent";
                public const string FTotalMachineAtFactory_Crosstab_Borrow = "Sp_333_Rpt_FTotalMachineAtFactory_Crosstab_Borrow";
                public const string FQTotalMachineAtFactory_Borrow = "Sp_333_Rpt_FQTotalMachineAtFactory_Borrow";
                public const string FLossDetails = "Sp_333_Rpt_FLossDetails";
                public const string FReturnDetails = "Sp_333_Rpt_FReturnDetails";
                public const string FTonKhoTongHop = "Sp_333_Rpt_FTonKhoTongHop";
                public const string QTotalInstock1 = "Sp_333_Rpt_QTotalInstock1";
                public const string QTotalInStockAtPresent = "Sp_333_Rpt_FTotalInStockAtPresent";
                public const string QMonthlyInStock_Query = "Sp_333_Rpt_QMonthlyInStock_Query";
                public const string QMonthlyInStock_QueryWithRange = "Sp_333_Rpt_QMonthlyInStock_QueryWithRange";
                public const string QMonthlyInStock = "Sp_333_Rpt_FMonthlyInStock";
                public const string QMonthlyInStockWithRange = "Sp_333_Rpt_FMonthlyInStockWithRange";
                public const string FDailyBroken = "Sp_333_Rpt_FDailyBroken";
                public const string QMonthlyBroken2_CrosstabAmount_USD = "Sp_333_Rpt_QMonthlyBroken2_CrosstabAmount_USD";
                public const string QMonthlyBroken2_CrosstabQty = "Sp_333_Rpt_QMonthlyBroken2_CrosstabQty";
                public const string QMonthlyBroken_Machine_CrosstabAmount_USD = "Sp_333_Rpt_QMonthlyBroken_Machine_CrosstabAmount_USD";
                public const string QMonthlyBroken_Machine_CrosstabQty = "Sp_333_Rpt_QMonthlyBroken_Machine_CrosstabQty";
                public const string QMonthlyBroken_Customer2_CrosstabQty = "Sp_333_Rpt_QMonthlyBroken_Customer2_CrosstabQty";
                public const string QMonthlyBroken_Customer2_CrosstabAmount_USD = "Sp_333_Rpt_QMonthlyBroken_Customer2_CrosstabAmount_USD";
                public const string QMonthlyBroken3_CrosstabToolGroupAmount = "Sp_333_Rpt_QMonthlyBroken3_CrosstabToolGroupAmount";
                public const string QMonthlyBroken3_Crosstab_ToolGroupQty = "Sp_333_Rpt_QMonthlyBroken3_Crosstab_ToolGroupQty";
                public const string QMonthlyBroken_Material2_CrosstabAmount_USD = "Sp_333_Rpt_QMonthlyBroken_Material2_CrosstabAmount_USD";
                public const string QMonthlyBroken_Material2_CrosstabQty = "Sp_333_Rpt_QMonthlyBroken_Material2_CrosstabQty";
                public const string QMonthlyBroken_Mistake2_CrosstabAmount_USD = "Sp_333_Rpt_QMonthlyBroken_Mistake2_CrosstabAmount_USD";
                public const string QMonthlyBroken_Mistake2_CrosstabQty = "Sp_333_Rpt_QMonthlyBroken_Mistake2_CrosstabQty";
                public const string QTotalMachineBroken_Crosstab = "Sp_333_Rpt_QTotalMachineBroken_Crosstab";
            }

        }
        #endregion

        #region Form Title
        public class Form
        {
            public class MessageBox
            {
                public const string Error = "Error";
                public const string Warning = "Warning";
                public const string Notice = "Notice";
                public const string Message = "Message";
                public const string Confirmation = "Confirmation";
            }

            public class BasicList
            {
                public const string Name = "Basic List";

            }

        }
        #endregion

        #region Form Message
        public class Message
        {
            public const string AddSuccess = "Data added Successfully";
            public const string AddSuccessAndQuestion = "Data added succesfully. Do you want to continue adding data?";
            public const string UpdateSuccessAndQuestion = "Data updated succesfully. Do you want to update again?";
            public const string AddFailed = "An error occurred while inserting the record to database. Please try again.";
            public const string UpdateSuccess = "Update Successfully";
            public const string UpdateFailed = "An error occurred while updating the record to database. Please try again.";
            public const string DeleteQuestion = "Do you want to permanently delete this item(s)?";
            public const string DeleteFailed = "Error occurred when deleting data. Please try again.";
            public const string FormAlreadyOpened = "This form is already opened.";
            public const string TableIsNull = "No data to edit/delete.";
            public const string QuestionUpdateTool = "Are you sure you want to replace the data from {0} into {1}?";
            public const string NoDataToExport = "No data to export.";
            public const string ErrorToExport = "cannot export.";
            public const string ImportSuccessfully = "Import {0} row(s) successfully. Do you want to refresh data now?";
            public const string ImportSuccessfullyLog = "Table [333_Import]: Import {0} row(s) successfully.";
            public const string ImportFailedLog = "Table [333_Import]: Import data failed.\n Message: {0}";
            public const string QuestionOpenFileExport = "Do you want to open the file?";

            public class Frequency
            {
                public const string FrequencyIDCantEmpty = "\"Frequency ID\" cannot be empty.";
                public const string FrequencyNameCantEmpty = "\"Frequency Name\" cannot be empty.";
                public const string FrequencyHasExisted = "This \"Frequency ID\" has existed.";
            }
            public class Borrow
            {
                public const string DateCantEmpty = "\"Date\" cannot be empty.";
                public const string ToolIDCantEmpty = "Please select \"Tool Name\".";
                public const string QuantityCantEmpty = "\"Quantity\" cannot be empty.";
                public const string StaffCantEmpty = "Please select \"Staff\".";
                public const string MachineCantEmpty = "Please select \"Machine\".";
                public const string MachineNotBorrow = "Machine {0} have not borrowed tool {1}.";
                public const string MachineBorrow = "Machine {0} have borrowed tool {1}!. \nQuantity: {2}";
                public const string WrongQuantity = "There are (is) only {1} tool(s) {0} in the warehouse at this time. \nSo you cannot borrow {2} tool(s).";
                public const string WrongQuantity2 = "There are (is) {1} tool(s) {0} in the warehouse.\nSo you adjust the quantity to {2} is inappropriate.\nPlease check this again.";
                public const string QuantityMustGreaterZero = "The quantity must be greater than 0.";
                public const string ToolOutStock = "There is no this tool in the warehouse at this time.";
                public const string ToolInStock = "There are (is) {1} tool(s) {0} in the warehouse at this time.";
                public const string ToolIDInvalid = "Invalid ToolID.";
                public const string StaffIDInvalid = "Invalid StaffID.";
                public const string MachineIDInvalid = "Invalid MachineID.";

            }
            public class Broken
            {
                public const string DateCantEmpty = "\"Date\" cannot be empty.";
                public const string ToolIDCantEmpty = "Please select \"Tool Name\".";
                public const string ToolIDInvalid = "Invalid ToolID.";
                public const string MachineInvalid = "Invalid MachineID.";
                public const string MistakeInvalid = "Invalid MistakeID.";
                public const string PartInvalid = "Invalid PartID.";
                public const string ProcessStatusInvalid = "Invalid ProcessStatusID.";
                public const string RotateInvalid = "Invalid RotateID.";
                public const string ToKindInvalid = "Invalid ToolID (Change Kind).";
                public const string QuantityCantEmpty = "\"Quantity\" cannot be empty.";
                public const string MistakeCantEmpty = "Please select \"Mistake\".";
                public const string MachineCantEmpty = "Please select \"Machine\".";
                public const string StatusCantEmpty = "Please select \"Status\".";
                public const string LossNoCantEmpty = "\"Loss No.\" cannot be empty.";
                public const string PartCantEmpty = "Please select \"Part\".";
                public const string ProcessStatusCantEmpty = "Please select \"Process Status\".";
                public const string RotateCantEmpty = "Please select \"Rotate\".";
                public const string StandardSpeedCantEmpty = "\"Standard Speed\" cannot be empty.";
                public const string RealitySpeedCantEmpty = "\"Reality Speed\" cannot be empty.";
                public const string ToKindCantEmpty = "Please select \"To Kind\".";
                public const string MachineNotBorrow = "Machine {0} have not borrowed tool {1}. \nSo this tool cannot be broken on this machine.";
                public const string MachineBorrow = "Machine {0} has borrowed tool {1}. \nQuantity: {2}.";
                public const string QuantityMustGreaterZero = "The quantity must be greater than 0.";
                public const string WrongQuantity = "You should decrease the quantity of tool {0} to {1}.\nSo the quantity of broken tool cannot be {2}.";
                public const string WrongQuantity2 = "The old quantity of broken tool: {0}.\nThe new quantity of broken tool which you entered: {1}.\nBut the quantity of {2} tool which machine {3} borrowed are (is): {4}.\nPlease check this again.";


            }
            public class Import
            {
                public const string ToolIDCantEmpty = "Please select \"Tool Name\".";
                public const string DateCantEmpty = "Please select \"Date\".";
                public const string PriceCantEmpty = "\"Price\" cannot be empty.";
                public const string MakerCantEmpty = "Please select \"Maker\".";
                public const string SupplierCantEmpty = "Please select \"Supplier\".";
                public const string QuantityCantEmpty = "\"Quantity\" cannot be empty.";
                public const string QuantityMustGreaterZero = "Quantity must be greater than 0.";
                public const string PriceMustGreaterZero = "Price (JPY) must be greater than 0.";

            }
            public class JustNew
            {
                public const string DateCantEmpty = "\"Date\" cannot be empty.";
                public const string ToolIDCantEmpty = "Please select \"Tool Name\".";
                public const string QuantityCantEmpty = "\"Quantity\" cannot be empty.";
                public const string QuantityMustGreaterZero = "The quantity must be greater than 0.";
                public const string WrongQuantity = "There are (is) {1} tools {0} in the import warehouse.\nSo you enter the quantity of used tool {2} is greater than the quantity of imported tool.";
                public const string WrongQuantity2 = "There are (is) {1} tools {0} in the import warehouse. \nSo you adjust the quantity of used tool to {2} is inappropriate. Please check this again.";
                public const string ImportQuantity = "There are (is) {1} tools {0} in the import warehouse.";
                public const string ToolIDInvalid = "Invalid ToolID.";

            }
            public class Kind
            {
                public const string KindIDCantEmpty = "\"Kind ID\" cannot be empty.";
                public const string KindNameCantEmpty = "\"Kind Name\" cannot be empty.";
                public const string KindHasExisted = "This \"Kind ID\" has existed.";
            }
            public class Mistake
            {
                public const string MistakeIDCantEmpty = "\"Mistake ID\" cannot be empty.";
                public const string MistakeNameCantEmpty = "\"Mistake Name\" cannot be empty.";
                public const string MistakeHasExisted = "This \"Mistake ID\" has existed.";
            }
            public class ProcessStatus
            {
                public const string ProcessStatusIDCantEmpty = "\"Process Status\" ID cannot be empty.";
                public const string ProcessStatusNameCantEmpty = "\"Process Status Name\" cannot be empty.";
                public const string ProcessStatusHasExisted = "This \"Process Status ID\" has existed.";
            }
            public class QTool
            {
                public const string ToolIDCantEmpty = "\"QTool ID\" cannot be empty.";
                public const string ToolNameCantEmpty = "\"QTool Name\" cannot be empty.";
                public const string ToolHasExisted = "This \"QTool ID\" has existed.";
                public const string MakerToolNameCantEmpty = "\"Maker's Tool Name\" cannot be empty.";
                public const string RRIToolNameCantEmpty = "\"RRI's Tool Name\" cannot be empty.";
                public const string PriceCantEmpty = "\"Price\" cannot be empty.";
                public const string SafeQtyCantEmpty = "\"Safe Quantity\" cannot be empty.";
            }
            public class Return
            {
                public const string DateCantEmpty = "\"Date\" cannot be empty.";
                public const string ToolIDCantEmpty = "Please select \"Tool Name\".";
                public const string QuantityCantEmpty = "\"Quantity\" cannot be empty.";
                public const string StaffCantEmpty = "Please select \"Staff\".";
                public const string MachineCantEmpty = "Please select \"Machine\".";
                public const string StatusCantEmpty = "Please select \"Status\".";
                public const string MachineNotBorrow = "Machine {0} has not borrowed tool {1}.\nPlease check this again. The machine which not borrow the tool it will never return that tool.";
                public const string MachineBorrow = "Machine {0} has borrowed {1} tools {2}.";
                public const string QuantityMustGreaterZero = "The quantity must be greater than 0.";
                public const string WrongQuantity = "The quantity of returned tool: {0}. \nThe quantity of borrowed tool: {1}. \nSo the quantity of returned tool cannot be greater than the quantity of borrowed. Please check this again.";
                public const string WrongQuantity2 = "The quantity of borrowed tool on machine: {1}. \nThe old quantity of returned tool: {0}. \nBut the new quantity which you entered: {2} is inappropriate.\nPlease check this again.";
                public const string ResultQuantity = "Machine {0} has borrowed {1} tool(s) {2}.\nThis machine return {3} tool(s) today. \nSo the quantity of borrowed tool on this machine: {4}";

            }
            public class Rotate
            {
                public const string RotateIDCantEmpty = "\"Rotate ID\" cannot be empty.";
                public const string RotateNameCantEmpty = "\"Rotate English Name\" cannot be empty.";
                public const string RotateHasExisted = "This \"Rotate ID\" has existed.";
            }
            public class Tool
            {
                public const string ToolIDCantEmpty = "\"Tool ID\" cannot be empty.";
                public const string ToolNameCantEmpty = "\"Tool Name\" cannot be empty.";
                public const string ToolHasExisted = "This \"Tool ID\" has existed.";
                public const string MakerToolNameCantEmpty = "\"Maker's Tool Name\" cannot be empty.";
                public const string PriceCantEmpty = "\"Price\" cannot be empty.";
                public const string PriceMustGreaterZero = "\"Price\" must be greater than 0.";
                public const string SafeQtyCantEmpty = "\"Safe Quantity\" cannot be empty.";
                public const string SafeQtyMustGreaterZero = "\"Safe Quantity\" must be greater than 0.";
                public const string MakerCantEmpty = "Please select \"Maker\".";
                public const string FrequencyCantEmpty = "Please select \"Frequency\".";
                public const string ToolGroupCantEmpty = "Please select \"Tool Group\".";
            }
            public class ToolGroup
            {
                public const string ToolGroupIDCantEmpty = "\"Tool Group ID\" cannot be empty.";
                public const string ToolGroupNameCantEmpty = "\"Tool Group Name\" cannot be empty.";
                public const string ToolGroupHasExisted = "This \"Tool Group ID\" has existed.";
            }
            public class ToolStatus
            {
                public const string ToolStatusIDCantEmpty = "\"Tool Status ID\" cannot be empty.";
                public const string ToolStatusNameCantEmpty = "\"Tool Status Name\" cannot be empty.";
                public const string ToolStatusHasExisted = "This \"Tool Status ID\" has existed.";
            }

            public class ExchangeRate
            {
                public const string CurrentcyCantEmpty = "\"Currency\" cannot be empty.";
                public const string ExchangeRateCantEmpty = "\"Rate\" cannot be empty.";
                public const string ExchangeDateCantEmpty = "\"Exchange Date\" cannot be empty.";
            }

            public class Supplier
            {
                public const string SupplierIdCantEmpty = "\"Supplier ID\" cannot be empty.";
                public const string SupplierNameCantEmpty = "\"Supplier Name\" cannot be empty.";
                public const string SupplierCompanyCantEmpty = "\"Company\" cannot be empty.";
                public const string SupplierAddressCantEmpty = "\"Address\" cannot be empty.";
                public const string SupplierCountryIdCantEmpty = "\"Country\" cannot be empty.";
                public const string SupplierTelephoneCantEmpty = "\"Telephone\" cannot be empty.";
                public const string SupplierFaxCantEmpty = "\"Fax\" cannot be empty.";
                public const string SupplierCommodityCantEmpty = "\"Commodity\" cannot be empty.";
                public const string SupplierHasExisted = "This \"Supplier ID\" has existed.";
                public const string SupplierIDInvalid = "Invalid SupplierID.";

            }

            public class Maker
            {
                public const string MakerIDCantEmpty = "\"Maker ID\" cannot be empty.";
                public const string MakerNameCantEmpty = "\"Maker Name\" cannot be empty.";
                public const string MakerHasExisted = "This \"Maker ID\" has existed.";
                public const string MakerIDInvalid = "Invalid MakerID.";

            }

        }
        #endregion

        #region Configuration
        public class Configuration
        {
            public class FilterFile
            {
                public const string Excel = "Excel 2007-2013|*.xlsx|Excel 97-2003 (*.xls)|*.xls";
            }
            

            public class ToolType
            {
                public const int IsTool = 0;
                public const int IsQTool = 1;
            }

            public class ProcessStatus
            {
                public const int True = 1;
                public const int False = 0;
                public const string TrueStr = "Change Kind";
                public const string FalseStr = "Delete";
            }

            public class Broken
            {
                public const int ProcessDelete = 0;
                public const int ProcessChangeKind = 1;
            }

            public class ReportName
            {
                public const int FImportDetails = 1;
                public const int FMonthlyImport = 2;
                public const int FUseDetails = 3;
                public const int FNewOldDetails = 4;
                public const int FBorrowDetails = 5;
                public const int FTotalMachineAtFactoryBorrowAtPresent = 6;
                public const int FTotalMachineAtFactoryCrosstabBorrow = 7;
                public const int FTotalMachineAtFactoryBorrow = 8;
                public const int FLossDetails = 9;
                public const int FReturnDetails = 10;
                public const int FTonKhoTongHop = 11;
                public const int QTotalInstock1 = 12;
                public const int QTotalInStockAtPresent = 13;
                public const int QMonthlyInStock_Query = 14;
                public const int QMonthlyInStock = 15;
                public const int FDailyBroken = 16;
                public const int QMonthlyBroken2CrosstabAmountUSD = 17;
                public const int QMonthlyBroken2CrosstabQty = 18;
                public const int QMonthlyBrokenMachineCrosstabAmountUSD = 19;
                public const int QMonthlyBrokenMachineCrosstabQty = 20;
                public const int QMonthlyBrokenCustomer2CrosstabQty = 21;
                public const int QMonthlyBrokenCustomer2CrosstabAmountUSD = 22;
                public const int QMonthlyBroken3CrosstabToolGroupAmount = 23;
                public const int QMonthlyBroken3CrosstabToolGroupQty = 24;
                public const int QMonthlyBrokenMaterial2CrosstabAmountUSD = 25;
                public const int QMonthlyBrokenMaterial2CrosstabQty = 26;
                public const int QMonthlyBrokenMistake2CrosstabAmountUSD = 27;
                public const int QMonthlyBrokenMistake2CrosstabQty = 28;
                public const int QTotalMachineBrokenCrosstab = 29;


            }

            public class LogFileName
            {
                public const string Import = "DataImportLog-Import.log";
                public const string JustNew = "DataImportLog-JustNew.log";
                public const string Borrow = "DataImportLog-Borrow.log";
                public const string Broken = "DataImportLog-Broken.log";
                public const string Return = "DataImportLog-Return.log";
                public const string Tool = "DataImportLog-Tool.log";
                
            }

            public class DateRangeTitle
            {
                public const string Today = "Today";
                public const string SixMonths = "6 Months";
                public const string OneYear = "1 Year";
                public const string TwoYears = "2 Years";
                public const string AllTime = "All time";
                
            }

        }
        #endregion
    }
}
